﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Medals.aspx.vb" Inherits="MyProject.WebForm9" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <b>For each 5 items of content added you will receive a medal and a place on the Medals table!</b><br />
<br />
More user statistics can be found
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="userstats.aspx">here!</asp:HyperLink>
<br />
<br /> <br />

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
           DataSourceID="AccessDataSource1">
        <Columns>
            <asp:BoundField DataField="Author" headertext = "Author"
                SortExpression="Author" />
                        <asp:TemplateField> 
            <ItemTemplate><h1> <%#getmedals(eval("medals"))%> </h1></ItemTemplate>
                     
                                 </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
        DataFile="~/App_Data/AssignmentDB.accdb" 
        SelectCommand="SELECT [Author], [CountOfItemName], [Medals] FROM [Medals] ORDER BY [Medals] DESC">
    </asp:AccessDataSource>
</asp:Content>
